﻿

-- 检测监视点是否有人员或者设备
create procedure [dbo].[JsdInfo_HaveRyOrSb]
@jsdbh varchar(18)
as

select 1 from JsdRyqx_Info where Jsdbh like @Jsdbh+'%'
union
select 1 from Jsdsb_Info where Jsdbh like @Jsdbh+'%'